Waiting for query cache lock
Short Description
This state occurs while a session is waiting to take the query cache lock.
Detailed Description​
This state occurs while a session is waiting to take the query cache lock. This can happen for any statement that needs to perform some query cache operation, such as an INSERT or DELETE that invalidates the query cache, a SELECT that looks for a cached entry, RESET QUERY CACHE, and so forth.
The Query Cache is deprecated at MySQL 5.7.20 and removed in MySQL 8.0
How to reduce this wait​
Not available yet. Contributions welcome.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.